home *** CD-ROM | disk | FTP | other *** search
/ Power Tools 1993 November - Disc 2 / Power Tools Plus (Disc 2 of 2)(November 1993)(HP).iso / hotlines / gsyhl / dbfeat / sybase.txt < prev    next >
Text File  |  1993-05-04  |  29KB  |  516 lines
  1.                       STRATEGIC PROFILE OF THIRD-PARTY RELATIONAL DATABASES
  2.  
  3.                                                  ------SYBASE Ver 4.9.1----
  4.  
  5. LANGUAGES SUPPORT
  6. ------------------------------------------------------------------------
  7. Japanese                                     Yes
  8. ------------------------------------------------------------------------
  9. Hanggui                                      No
  10. ------------------------------------------------------------------------
  11. Sorting Sequences                            Yes
  12. ------------------------------------------------------------------------
  13. Error messges                                Yes
  14. ------------------------------------------------------------------------
  15. Upper/Lower case conversion                  Yes
  16. ------------------------------------------------------------------------
  17. Sorting/Collating sequences                  Yes
  18. ------------------------------------------------------------------------
  19. Multiple character set support               Yes
  20. ------------------------------------------------------------------------
  21. 2-Byte character set                         Yes
  22. ------------------------------------------------------------------------
  23.  
  24.  
  25. GRAPHICS PRESENTATION                        Data Workbench
  26. ------------------------------------------------------------------------
  27. WYSIWYG environment                          No
  28. ------------------------------------------------------------------------
  29. Product graphics directly from query         No
  30.  
  31.  
  32. CONNECTIVITY/GATEWAYS
  33. ------------------------------------------------------------------------
  34. DB2 Connectivity                             Ingres, VMS - yes; DB2
  35. ------------------------------------------------------------------------
  36. VAX VMS, IMS, Allbase, Oracle, Rdb           Not yet on HP; no for Allbase
  37. ------------------------------------------------------------------------
  38. PC Integration                               Can run on OS/2, DOS, Mac,
  39.                                                                                           Windows
  40.  
  41. PORTABILITY
  42. ------------------------------------------------------------------------
  43. ANSI 89 (level 2) compatibility              No
  44. ------------------------------------------------------------------------
  45. Hardware Platform Supported                  HP9000, VAX, IBM Mainframe,
  46. ---------------------------------------------Unix systems, Macintosh,
  47.                                                                                           IBM PC
  48.                                                                                           --------------------------
  49. Operating System Supported                   HP-UX, Unix, VAX/VMS, OS/2,
  50. ---------------------------------------------IBM/MVS, DOS
  51.                                                                                           ---------------------------
  52. Support for Non-Relational Database          Yes
  53. ------------------------------------------------------------------------
  54.  
  55.  
  56. DATA TYPES
  57. -------------------------------------------------------------------------
  58. Character                                    Yes; 255 chars max
  59. ------------------------------------------------------------------------
  60. Integer                                      Yes
  61. ------------------------------------------------------------------------
  62. Float                                        Yes
  63. ------------------------------------------------------------------------
  64. Logical                                      Yes; using integers like C
  65. ------------------------------------------------------------------------
  66. Currency                                     Yes
  67. ------------------------------------------------------------------------
  68. Date                                         Yes
  69. ------------------------------------------------------------------------
  70. Time                                         Yes
  71. ------------------------------------------------------------------------
  72. Long Text                                    2 Billion max
  73. ------------------------------------------------------------------------
  74. Image (BLOBS)                                Var length binary column up
  75. ---------------------------------------------to 2 GB of binary data
  76.                                                                                         ---------------------------
  77. Support for Arrays                           No
  78. ------------------------------------------------------------------------
  79. User defined data type                       Yes, define in terms of data
  80. ---------------------------------------------type
  81.                                                                                        ---------------------------
  82. User defined functions and operators         Yes
  83. ------------------------------------------------------------------------
  84. Binary (Fixed / Var)                         Yes
  85. ------------------------------------------------------------------------
  86. Sound                                        As binary
  87. ------------------------------------------------------------------------
  88. Graphics                                     As binary
  89. ------------------------------------------------------------------------
  90. Facsimiles                                   As binary
  91.  
  92.  
  93. DISTRIBUTION                                 Open Server
  94. ------------------------------------------------------------------------
  95. Parallel Server
  96. ------------------------------------------------------------------------
  97. Location Transparency                        No
  98. ------------------------------------------------------------------------
  99. Distributed Query Processing                 Yes
  100. ------------------------------------------------------------------------
  101. Distributed query optimizer                  No
  102. ------------------------------------------------------------------------
  103. Distributed transaction processing           Yes; not automatic, but
  104. (2-phase commit)                             built into application on
  105. ---------------------------------------------front end
  106.                                                                                            ---------------------------
  107. Support for data replication
  108. ------------------------------------------------------------------------
  109. Access to heterogeneous databases            None; possible using Open
  110. ---------------------------------------------Server
  111.                                                                                           ---------------------------
  112. Loosely coupled support                      No
  113. ------------------------------------------------------------------------
  114. Distributed data dictionary
  115. ------------------------------------------------------------------------
  116. Max. no. of simultaneously connected dbs     Unlimited
  117.  
  118.  
  119. ARCHITECTURE
  120. ------------------------------------------------------------------------
  121. Client/Server                                Yes
  122. ------------------------------------------------------------------------
  123. Multiserver                                  Yes
  124. ------------------------------------------------------------------------
  125. Maximum number of server/systems             No limit
  126. ------------------------------------------------------------------------
  127. Maximum number of user/server                Platform dependent
  128. ---------------------------------------------2048 on HP-UX
  129.                                                                                            ---------------------------
  130. Maxiumu number of user/system                No limit
  131. ------------------------------------------------------------------------
  132. Multithreaded server                         Yes
  133. ------------------------------------------------------------------------
  134. Support for symmetric multiprocessors        Yes
  135. ------------------------------------------------------------------------
  136. Open architecture (APIs available)           Yes
  137. ------------------------------------------------------------------------
  138. Loosely coupled support                      No
  139. ------------------------------------------------------------------------
  140.  
  141.  
  142. UNDERLYING FILE STRUCTURE                    Raw I/O for Unix
  143. ------------------------------------------------------------------------
  144. DATABASE PARAMETERS
  145. -------------------------------------------------------------------------
  146. Database size                                No limit
  147. ------------------------------------------------------------------------
  148. Database/server                              32,767
  149. ------------------------------------------------------------------------
  150. Tables/database                              2 billion
  151. ------------------------------------------------------------------------
  152. Records/database                             No limit
  153. ------------------------------------------------------------------------
  154. Record size                                  No limit
  155. ------------------------------------------------------------------------
  156. Fields/record                                250
  157. ------------------------------------------------------------------------
  158. Indexes/database                             251/table
  159. ------------------------------------------------------------------------
  160. Database connected to a client               32K
  161. ------------------------------------------------------------------------
  162.  
  163.  
  164. USER INTERFACE                               Menu-driven
  165. ------------------------------------------------------------------------
  166. Menu bypass                                  No
  167. ------------------------------------------------------------------------
  168. Contextual help                              Yes
  169. ------------------------------------------------------------------------
  170. Tutorial                                     No
  171. ------------------------------------------------------------------------
  172. Ability to customize standard menus          No
  173. ------------------------------------------------------------------------
  174. Support for colors
  175. ------------------------------------------------------------------------
  176. Support for graphical user interface         Yes
  177. ------------------------------------------------------------------------
  178.  
  179.  
  180. SCREEN FORMS                                 Built in APT Workbench
  181. ------------------------------------------------------------------------
  182. Default form generator                       Yes
  183. ------------------------------------------------------------------------
  184. Customized                                   Yes
  185. ------------------------------------------------------------------------
  186. Multiple tables/forms                        Yes
  187. ------------------------------------------------------------------------
  188. Multiple screens/forms                       Yes
  189. ------------------------------------------------------------------------
  190. Embedded processing (if-then-else, display   Yes
  191.                                        aggregates)
  192. ------------------------------------------------------------------------
  193.  
  194.  
  195. FIELD ATTRIBUTES ON FORMS
  196. ------------------------------------------------------------------------
  197. Case conversion                              Yes
  198. ------------------------------------------------------------------------
  199. Default Value                                Yes
  200. ------------------------------------------------------------------------
  201. Required field                               Yes
  202. ------------------------------------------------------------------------
  203. Acceptable values                            Yes
  204. ------------------------------------------------------------------------
  205. Verification (enter data twice)              No
  206. ------------------------------------------------------------------------
  207. Formatting of data                           Yes
  208. ------------------------------------------------------------------------
  209. Calculated fields                            Yes
  210. ------------------------------------------------------------------------
  211. Display/read only (no entry/update)          Yes
  212. ------------------------------------------------------------------------
  213. Hidden                                       Yes
  214. ------------------------------------------------------------------------
  215. Prompt (for data entry)                      Yes
  216. ------------------------------------------------------------------------
  217. Customized help                              Yes
  218. ------------------------------------------------------------------------
  219. Video display                                Yes
  220. ------------------------------------------------------------------------
  221. Ability to change field attribute
  222.           dynamically
  223. ------------------------------------------------------------------------
  224.  
  225.  
  226. QUERY-BY-FORMS                               VQL, Data Workbench
  227. ------------------------------------------------------------------------
  228. Exact match                                  Yes
  229. ------------------------------------------------------------------------
  230. Relational operators                         Yes
  231. ------------------------------------------------------------------------
  232. List of values                               No
  233. ------------------------------------------------------------------------
  234. Wild cards                                   Yes
  235. ------------------------------------------------------------------------
  236. Maximum/Minimum values                       No
  237. ------------------------------------------------------------------------
  238. Print query results                          Yes
  239. ------------------------------------------------------------------------
  240. Pass results to report writer                Yes
  241. ------------------------------------------------------------------------
  242. Text search                                  Yes
  243. ------------------------------------------------------------------------
  244.  
  245.  
  246. SQL
  247. ------------------------------------------------------------------------
  248. Standard SQL statements                      Yes
  249. ------------------------------------------------------------------------
  250. Data Definition language (DDL)               Yes
  251. ------------------------------------------------------------------------
  252. Data manipulation language (DML)             Yes
  253. ------------------------------------------------------------------------
  254. Extension to SQL                             Transact-SQL
  255. ------------------------------------------------------------------------
  256. Commit/rollback transaction                  Yes
  257. ------------------------------------------------------------------------
  258. Execute operating systems commands           No; yes in APT-SQL
  259. ------------------------------------------------------------------------
  260. Load/unload data to/from ASCII file          Yes
  261. ------------------------------------------------------------------------
  262. Additional data definition statements        Yes
  263. ------------------------------------------------------------------------
  264. Control-of-flow logic                        Yes
  265. ------------------------------------------------------------------------
  266. Support for embedded SQL                     Yes; C, Cobol
  267. ------------------------------------------------------------------------
  268. Suport for dynamic SQL                       Yes
  269. ------------------------------------------------------------------------
  270. Can create new tables with query results     Yes
  271. ------------------------------------------------------------------------
  272. Stored queries                               Yes
  273. ------------------------------------------------------------------------
  274. CASE-insensitive (eg., filed names)          No
  275. ------------------------------------------------------------------------
  276. Can call C routines                          Yes in APT-SQL and Yes via
  277. ---------------------------------------------Open Server
  278.                                                                                           ---------------------------
  279. How create SQL queries/statements            Interactive SQL Editor
  280. ------------------------------------------------------------------------
  281. Query optimizer-statistical                  Yeseractive SQL Editor
  282. ------------------------------------------------------------------------
  283. Syntax independent performance               Yes
  284. ------------------------------------------------------------------------
  285. Optimization method                          Cost-based
  286. ------------------------------------------------------------------------
  287. Procedural extension to SQL                  Yes
  288. ------------------------------------------------------------------------
  289. Remote SQL database calls                    Yes; via Open Server
  290. ------------------------------------------------------------------------
  291.  
  292.  
  293. B-TREE INDEXING
  294. -------------------------------------------------------------------------
  295. Maximum number of indexes                    251/table
  296. ------------------------------------------------------------------------
  297. Maximum number of fields/index               16
  298. ------------------------------------------------------------------------
  299. Maximum size of index key                    256 chars
  300. ------------------------------------------------------------------------
  301. Order options                                Ascending
  302. ------------------------------------------------------------------------
  303. Unique index                                 Yes
  304. ------------------------------------------------------------------------
  305. Clustered index                              Yes
  306. ------------------------------------------------------------------------
  307. Other file access methods (hash, etc.)       None
  308. ------------------------------------------------------------------------
  309.  
  310.  
  311. REPORT WRITER                                Included in Data Workbench
  312. ------------------------------------------------------------------------
  313. Non Procedural                               Yes
  314. ------------------------------------------------------------------------
  315. Default report generator                     Yes
  316. ------------------------------------------------------------------------
  317. Interactive report generator                 Yes
  318.            using screen forms
  319. ------------------------------------------------------------------------
  320. Interactive debugging                        Yes
  321. ------------------------------------------------------------------------
  322. Input source                                 Query only (SQL or VQL)
  323. ------------------------------------------------------------------------
  324. Multiple tables                              Yes
  325. ------------------------------------------------------------------------
  326. Page formatting                              Yes
  327. ------------------------------------------------------------------------
  328. Headers and footers                          Yes
  329. ------------------------------------------------------------------------
  330. Data formatting                              Yes
  331. ------------------------------------------------------------------------
  332. Sort data                                    Yes in Query
  333. ------------------------------------------------------------------------
  334. Aggregate functions                          Yes
  335. ------------------------------------------------------------------------
  336. Logical processing (if-then logic)           No; yes in APT-SQL
  337. ------------------------------------------------------------------------
  338. User variables                               Yes
  339. ------------------------------------------------------------------------
  340. Prompt for input variables at run time       Yes
  341. ------------------------------------------------------------------------
  342.  
  343.  
  344. APPLICATION GENERATOR                        APT-4GL, APT-Build
  345. ------------------------------------------------------------------------
  346. CASE Tools
  347. ------------------------------------------------------------------------
  348. 4GL Interface                                Yes; APT-4GL, APT-Build
  349. ------------------------------------------------------------------------
  350. Ability to design application menus          Yes
  351. ------------------------------------------------------------------------
  352. Default menu generator                       Yes
  353. ------------------------------------------------------------------------
  354. Custom help                                  Yes
  355. ------------------------------------------------------------------------
  356. Consistent module interface                  Yes
  357. ------------------------------------------------------------------------
  358. Toolset for multimedia application           Yes
  359. ------------------------------------------------------------------------
  360.  
  361. ABILITY TO CREATE VIEWS                      Yes
  362. ---------------------------------------------------------------------------
  363.  
  364.  
  365. INTEGRITY                                    Yes
  366. --------------------------------------------------------------------------
  367. Transaction logging                          Yes
  368. ------------------------------------------------------------------------
  369. Commit/rollback transaction                  Yes
  370. ------------------------------------------------------------------------
  371. Roll forward                                 Yes
  372. ------------------------------------------------------------------------
  373. Referential integrity                        Yes; declarative (via triggers)
  374. ------------------------------------------------------------------------
  375. Field validation                             Yes; (rules/stored procedures)
  376. ------------------------------------------------------------------------
  377. Support for business rules                   Yes
  378. ------------------------------------------------------------------------
  379. Database Triggers                            Yes
  380. ------------------------------------------------------------------------
  381. Database event alerters                      Yes
  382. ------------------------------------------------------------------------
  383. Entity integrity                             Yes
  384. ------------------------------------------------------------------------
  385. Domain Integrity                             Yes
  386. ------------------------------------------------------------------------
  387.  
  388.  
  389. STORED PROCEDURES                            Yes
  390. ------------------------------------------------------------------------
  391. Precompiled                                  Yes
  392. ------------------------------------------------------------------------
  393. Can be nested                                Yes
  394. ------------------------------------------------------------------------
  395. Ability to store and execute                 Yes
  396.          procedures on the server
  397. ------------------------------------------------------------------------
  398.  
  399.  
  400. CONCURRENCY CONTROL LOCKING LEVELS
  401. ------------------------------------------------------------------------
  402. Database                                     No
  403. ------------------------------------------------------------------------
  404. Table                                        Rarely; must be specifically
  405. ---------------------------------------------requested
  406.                                                                                           ---------------------------
  407. Record (row)                                 No
  408. ------------------------------------------------------------------------
  409. Page                                         Yes; default
  410. ------------------------------------------------------------------------
  411. Lock type:  shared, update, exclusive        Shared (read) Exlusive (update)
  412. ------------------------------------------------------------------------
  413. Deadlock recognition                         Yes
  414. ------------------------------------------------------------------------
  415. Other data isolation levels                  Browse mode locking
  416.  
  417.  
  418. DATABASE SECURITY
  419. ------------------------------------------------------------------------
  420. Login password                               Yes
  421. ------------------------------------------------------------------------
  422. Multilevel access control                    Yes
  423. ------------------------------------------------------------------------
  424.           User                                    Yes
  425. ------------------------------------------------------------------------
  426.           Group                                   Yes; centralized at server
  427. ------------------------------------------------------------------------
  428.           Application                             Yes; centralized at server
  429. ------------------------------------------------------------------------
  430. Database-level access                        Yes
  431. ------------------------------------------------------------------------
  432. Table-level access                           Yes
  433. ------------------------------------------------------------------------
  434. Record-level access                          Yes
  435. ------------------------------------------------------------------------
  436. Field-level access                           Yes
  437. ------------------------------------------------------------------------
  438. Access by time of day                        Yes
  439. ------------------------------------------------------------------------
  440. Access by location (workstation)             No
  441. ------------------------------------------------------------------------
  442. Ability to define resource limits on user    Yes
  443.           queries (same as create views?)
  444. ------------------------------------------------------------------------
  445.  
  446.  
  447. AVAILABILITY
  448. ------------------------------------------------------------------------
  449. On-line backup                               Yes
  450. ------------------------------------------------------------------------
  451. On-line database changes                     Yes
  452. ------------------------------------------------------------------------
  453. Software-based disk mirroring                Yes
  454. ------------------------------------------------------------------------
  455.  
  456. Raw Input-Output                             Yes
  457. ------------------------------------------------------------------------
  458. Database can scan multiple physical          Yes
  459.           devices (disks)
  460. ------------------------------------------------------------------------
  461.  
  462. Support for CD-ROM, WORM Drives              Supported if they look like
  463. ---------------------------------------------a SCSI disk
  464.                                                                                          ---------------------------
  465.  
  466.  
  467. NETWORK SUPPORT
  468. ------------------------------------------------------------------------
  469.  
  470.  
  471. IMPORT / EXPORT CAPABILITY
  472. ------------------------------------------------------------------------
  473. Import formats                               ASCII delimited, fixed field
  474. ------------------------------------------------------------------------
  475. Export formats                               ASCII delimited, fixed field
  476. ------------------------------------------------------------------------
  477.  
  478.  
  479. DATABASE ADMINISTRATION
  480. ------------------------------------------------------------------------
  481. Screen based administrative utilities        No
  482. ------------------------------------------------------------------------
  483. Performance tuning                           Yes
  484. ------------------------------------------------------------------------
  485. Dynamic modification                         Yes
  486. ------------------------------------------------------------------------
  487. Dynamic disk space allocation                Yes
  488. ------------------------------------------------------------------------
  489.  
  490.  
  491. I/O REDUCTION TECHNIQUES
  492. ------------------------------------------------------------------------
  493. Fast Commit                                  Yes
  494. ------------------------------------------------------------------------
  495. Group Commit                                 Yes
  496. ------------------------------------------------------------------------
  497. Parallel Checkpoint on multiprocessor        Yes
  498.           systems
  499. ------------------------------------------------------------------------
  500. Index compression                            No
  501. ------------------------------------------------------------------------
  502. Data compression                             No
  503. ------------------------------------------------------------------------
  504. Multiblock Read/Write                        2K read/write
  505. ------------------------------------------------------------------------
  506.  
  507.  
  508. FAULT-TOLERANCE
  509. ------------------------------------------------------------------------
  510. Mirrored Discs                               Yes
  511. ------------------------------------------------------------------------
  512. Disc Failures                                Yes
  513. ------------------------------------------------------------------------
  514. CPU Failures                                 No
  515. ------------------------------------------------------------------------
  516.